Database - Interview Questions and Answers for 'Tata consultancy' | Search Interview Question

Database - Interview Questions and Answers for 'Tata consultancy' - 4 question(s) found - Order By Newest

Frequently asked to fresh graduates.

Q1. What is ACID ?

Ans. ACID stands for Atomicity, Consistency, Isolation, Durability is a set of properties of database transactions.

Atomicity means all or nothing. i.e parts of a transaction shouldn't commit if any one of them fails. Either the whole transaction should succeed or it should be complete rollback.

Consistency means that any transaction should lead database from one stabe state to another.

Isolation means that the execution of transaction results in a system state that would be obtained if transactions were executed serially.

Durability means that when a transaction is committed it forms the permanent state of database.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve database acid Asked in 7 Companies Intermediate}

Try 1 Question(s) Test

Q2. What is database Normalization ?

Database

Ans. https://en.wikipedia.org/wiki/Database_normalization

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve normalization database Asked in 35 Companies intermediate frequent}

Q3. Can we have foreign key reference to a non primary key column ?

Database

Ans. Yes, but the respective key in the foreign table should be declared Unique.

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve sql database oracle Asked in 2 Companies}

Q4. How do you fetch the records form database ?

Database

Ans. To fetch records from a database, you would use SELECT statements

Help us improve. Please let us know the company, where you were asked this question :

_{Like Discuss Correct / Improve Asked in 1 Companies}

Search Interview Questions

Help us and Others Improve. Please let us know the questions asked in any of your previous interview.